Housing Authority of Winston-Salem (HAWS)

500 West Fourth Street, Suite 300, Winston-Salem, NC, 27101
(336)727-8500
Website: www.haws.org



View your Free Credit Scores from All 3 Bureaus

Forsyth County

Section 8 Voucher Wait List   Open
  • logo
  • Ending: Apr 02, 2024
    Tue 09:00 AM

Description:

The Section 8 waiting list, which last opened in December 2021, will reopen on April 2, 2024 at 9 a.m. and close on April 4, 2024 at 5 p.m. Interested applicants can apply on haws.org an
Read More

Public Housing Wait List   Open
  • logo
  • Ending: N/A

Description:

According to recently updated public information sources, this agency appears to have open waiting list. Please contact them directly to confirm the current status of their waiting lists for
Read More

About Housing Authority of Winston-Salem (HAWS)

The Housing Authority of Winston-Salem offers a variety of professional services to ensure success of your privately owned or subsidized property. Our combined expertise in the areas of real estate development and property management and maintenance provides a unique approach for business solutions that fit your company’s needs.

The Housing Authority's core business involves real estate development and property management. The primary business goal is to diversify our portfolio of housing units and commercial real estate assets in order to help stabilize and revitalize local communities.

The Housing Authority partners with various businesses and service providers to accomplish our goals. These partnerships provide numerous business opportunities that promote economic growth and development within the city of Winston-Salem, Forsyth County and the state of North Carolina.


Program Summary for Housing Authority of Winston-Salem (HAWS)

Housing Authority of Winston-Salem (HAWS) is a public housing agency that helps provide decent and safe rental housing for eligible low-income families, the elderly, and persons with disabilities. Housing Authority of Winston-Salem (HAWS) manages several funded programs and has a total of 1,783 subsidized affordable housing units for rental assistance. Housing Authority of Winston-Salem (HAWS) administered a total of 4,664 Section 8 Vouchers. Housing Authority of Winston-Salem (HAWS) currently has low rent units and Section 8 Voucher as its program type. Housing Authority of Winston-Salem (HAWS) is located at 500 West Fourth Street, Suite 300, Winston-Salem, NC, 27101 and serves the city of Winston-Salem. Income limits, fair market rents and rent rates vary with each agency. Please contact Housing Authority of Winston-Salem (HAWS) at, (336)727-8500 for more information about coverage area and program availability.


Current Status Active
Size of Housing Authority of Winston-Salem (HAWS) compared nationally Large
Last Updated 04/12/2014
Total Numbers of Communities 21
Total numbers of Administered Section 8 Voucher 4,664
Total numbers of Administered Public Housing Units 1,783
Waiting list for the Housing Authority of Winston-Salem (HAWS) is currently Open


2022 Income Limits for Forsyth County, NC

HUD sets Income Limits for each area based on the median family income in that area. Each Public Housing Agency (PHA) will use the Income Limit set for the jurisdiction that the PHA covers. Therefore, a family may be eligible for one PHA but not another. The number of people in a household determines the Income Limit that is set for determining the family's eligibility for the program that they are applying for. Below are the Income Limits for Forsyth County, NC:

Median Income
$0
Income Limit Category
Persons in Family
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 50%
  • Very Low Income Limit
  • $23,400
  • $26,750
  • $30,100
  • $33,400
  • $36,100
  • $38,750
  • $41,450
  • $44,100
  • 30%
  • Extremely Low Income Limit
  • $14,050
  • $17,240
  • $21,720
  • $26,200
  • $30,680
  • $35,160
  • $39,640
  • $44,100
  • 80%
  • Low Income Limit
  • $37,400
  • $42,750
  • $48,100
  • $53,400
  • $57,700
  • $61,950
  • $66,250
  • $70,500

2017 Fair Market Rents for Forsyth County, NC

Fair Market Rents are HUD's determination of the average rents in a particular area for each bedroom size. The FMRs are set each year based on the rental rates of unsubsidized units so that participants in HUD programs have equal access for affordable housing. Here are the Fair Market Rents for Forsyth County, NC:

Efficiency One-Bedroom Two-Bedroom Three-Bedroom Four-Bedroom
$597 $611 $753 $1038 $1229



Agency Name City State Section 8 Voucher Housing Units Status Distance

Housing Authority

Housing Authority of Winston-Salem (HAWS) Program Type:
  • Section 8 Voucher
  • Low Rent Units
1,733
Total Subsidized Units for Rental Assistance Availability

Contact Housing Agency


credit_banner
protect-credit

Affordability Calculator

Please enter your MONTHLY gross income

(income before taxes...numbers only)


You should not to be paying more than

$

on your rent mortgage each month Why ?

Forsyth County Quick Facts

Population: 365,298
Persons Per Household: 2.45
Housing Units in Multi-units Structure: 25.2%
Homeownership Rate: 64.0%
Housing Units: 159,215
Yearly Income Per Person: $26,541
Median Household Income: $45,724
Application Log
Timestamp Level Category Message
23:34:14.584629 trace system.CModule
Loading "log" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.585045 trace system.CModule
Loading "request" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.585170 trace system.CModule
Loading "urlManager" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.587842 trace system.CModule
Loading "db" application component
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (21)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(54)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.587975 trace system.db.CDbConnection
Opening DB connection
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (21)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(54)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.589476 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `settings`
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (21)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(54)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.591794 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `settings`
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (21)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(54)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.592272 trace system.db.CDbCommand
Querying SQL: select value from settings where setting_key = "facebook_url"
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (94)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(54)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.592725 trace system.db.CDbCommand
Querying SQL: select value from settings where setting_key = "twitter_url"
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (94)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(56)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.593066 trace system.db.CDbCommand
Querying SQL: select value from settings where setting_key = "admin_email"
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (94)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(58)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.593379 trace system.db.CDbCommand
Querying SQL: select image from banner where status = "Active"
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(60)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.594301 trace system.db.CDbCommand
Querying SQL: select p.property_state,p.property_city
,(((acos(sin(("34.052235" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("34.052235" *pi()/180)) * cos((`lat`*pi()/180))
* cos((("-118.243683"- `lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as
distance from property p group by p.property_city HAVING distance <= 50
order by distance ASC
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(127)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.681474 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `state`
in /home/cavepear/rentalhousingdeals.com/protected/models/State.php (20)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2629)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.682849 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `state`
in /home/cavepear/rentalhousingdeals.com/protected/models/State.php (20)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2629)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.683326 trace system.db.CDbCommand
Querying SQL: select name from state where abbr = "NC" or name = "NC"
in /home/cavepear/rentalhousingdeals.com/protected/models/State.php (94)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2629)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.683933 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `seo_template`
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoTemplate.php
(24)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2631)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.685307 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `seo_template`
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoTemplate.php
(24)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2631)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.685726 trace system.db.CDbCommand
Querying SQL: select title,keyword,description from seo_template where 
home = '' and state = 'NC' and replace(replace(replace(`city`,'"',''),'/
',' '),'-',' ') = 'Winston Salem'  and individual_type = 'Housing
authority'
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoTemplate.php
(104)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2631)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.686080 trace system.db.CDbCommand
Querying SQL: select title,keyword,description from seo_template where 
home = 'Housing authority' and state = 'NC' and
replace(replace(replace(`city`,'"',''),'/ ',' '),'-',' ') = 'All'  and
individual_type = 'Housing authority'
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoTemplate.php
(104)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2638)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.686588 trace system.db.CDbCommand
Querying SQL: select seo_val from seo_settings where seo_key =
"searchha_title_detail"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2644)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.686976 trace system.db.CDbCommand
Querying SQL: select seo_val from seo_settings where seo_key =
"searchha_keyword_detail"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2645)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.687313 trace system.db.CDbCommand
Querying SQL: select seo_val from seo_settings where seo_key =
"searchha_description_detail"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2646)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.687640 trace system.db.CDbCommand
Querying SQL: Select id from housingauthority where
trim(replace(replace(replace(`name`,'"',''),'/ ',' '),'-',' ')) = 'Housing
Authority of Winston Salem (HAWS)' and
replace(replace(replace(`city`,'"',''),'/ ',' '),'-',' ') = 'Winston Salem'
and state='NC'  limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2659)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.691528 trace system.db.CDbCommand
Querying SQL: Select h.*,h.county as county_name from housingauthority as h
where h.id=2216 
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2664)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.691910 trace system.db.CDbCommand
Querying SQL: select op.ha_id,op.close_date, op.open_date, op.open_time,
op.close_time, op.source ,op.description, op.close_date_ha,
op.open_date_ha,op.open_time_ha,
op.close_time_ha,op.source_ha,op.description_ha from
Housingauthorityopenclosedate as op where  op.ha_id="NC012"
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2666)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.697035 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where id=1885
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2682)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.697691 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `ha_lead`
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2704)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.699781 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `ha_lead`
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2704)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.700885 trace system.CModule
Loading "widgetFactory" application component
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/detailHA.php
(78)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2708)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.701684 trace system.CModule
Loading "clientScript" application component
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/detailHA.php
(78)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2708)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.701953 trace system.CModule
Loading "assetManager" application component
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/detailHA.php
(78)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2708)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.705558 trace system.CModule
Loading "user" application component
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/detailHA.php
(494)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2708)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.705764 trace system.CModule
Loading "session" application component
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/detailHA.php
(494)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2708)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.706505 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `housingauthority_detail`
in
/home/cavepear/rentalhousingdeals.com/protected/models/HousingAuthorityDetail.php
(27)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/detailHA.php
(585)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2708)
23:34:14.708869 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `housingauthority_detail`
in
/home/cavepear/rentalhousingdeals.com/protected/models/HousingAuthorityDetail.php
(27)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/detailHA.php
(585)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2708)
23:34:14.709566 trace system.db.CDbCommand
Querying SQL: SELECT * FROM housingauthority_detail WHERE ha_code = 'NC012'
in
/home/cavepear/rentalhousingdeals.com/protected/models/HousingAuthorityDetail.php
(80)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/detailHA.php
(585)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2708)
23:34:14.718791 trace system.db.CDbCommand
Querying SQL: SELECT * FROM city_county_mapping WHERE
city_name="Winston-Salem" AND state_code= "NC" AND status ="1" LIMIT 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/countyincomelimit/incomelimit.php
(23)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/detailHA.php
(701)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2708)
23:34:14.737853 trace system.db.CDbCommand
Querying SQL: SELECT * FROM income_limits WHERE State_Alpha = "NC" AND
County_Name = "Forsyth County" LIMIT 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/countyincomelimit/incomelimit.php
(41)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/detailHA.php
(701)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2708)
23:34:14.744477 trace system.db.CDbCommand
Querying SQL: SELECT * FROM city_county_mapping WHERE
city_name="Winston-Salem" AND state_code= "NC" AND status ="1" LIMIT 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/countyfairmarketrent/fairmarketrent.php
(23)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/detailHA.php
(708)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2708)
23:34:14.763596 trace system.db.CDbCommand
Querying SQL: SELECT * FROM fair_market_rent WHERE state_code = "NC" AND
county_name = "Forsyth County" LIMIT 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/countyfairmarketrent/fairmarketrent.php
(42)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/detailHA.php
(708)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2708)
23:34:14.767864 trace system.db.CDbCommand
Querying SQL: (select p.id_property,p.property_title, p.property_address
,p.property_city,p.property_state,p.property_type ,
p.property_zip,pd.header_description,pd.header_value,pp.photo,
        (((acos(sin(('' *pi()/180)) * sin((`lat`*pi()/180))+cos((''
*pi()/180)) * cos((`lat`*pi()/180)) * cos(((''-
`lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as distance from property p 
        left join property_photo pp on p.id_property = pp.id_property and
pp.status = 'Active'
        left join property_deals pd on pd.id_property = p.id_property WHERE
p.status = 'Approved' and p.property_state = 'NC' and p.property_type =
'premium' 
            GROUP BY p.id_property 
            HAVING distance <= 25
            ORDER BY distance) 
            UNION ALL
            (select p.id_property,p.property_title, p.property_address
,p.property_city,p.property_state,p.property_type ,
p.property_zip,pd.header_description,pd.header_value,pp.photo,
        (((acos(sin(('' *pi()/180)) * sin((`lat`*pi()/180))+cos((''
*pi()/180)) * cos((`lat`*pi()/180)) * cos(((''-
`lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as distance from property p 
        left join property_photo pp on p.id_property = pp.id_property and
pp.status = 'Active'
        left join property_deals pd on pd.id_property = p.id_property WHERE
p.status = 'Approved' and p.property_state = 'NC' and p.property_type =
'general' 
            GROUP BY p.id_property 
            HAVING distance <= 25) LIMIT 20
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/similarpropertynearby/similarpropertynearby.php
(57)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/detailHA.php
(722)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2708)
23:34:14.806271 trace system.db.CDbCommand
Querying SQL: select h.*,(((acos(sin(("0.0000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("0.0000" *pi()/180)) * cos((`lat`*pi()/180)) *
cos((("0.0000"- `lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as distance from
housingauthority h HAVING distance <= 200  order by distance ASC limit 7
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/localhousingauthoritynearby/localhousingauthoritynearby.php
(23)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/detailHA.php
(833)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2708)
23:34:14.822273 trace system.CModule
Loading "coreMessages" application component
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/detailHA.php
(958)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2708)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:34:14.825264 trace system.db.CDbCommand
Querying SQL: SELECT * FROM city_county_mapping WHERE
city_name="Winston-Salem" AND state_code= "NC" AND status ="1" LIMIT 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/countyquickfacts/quickfacts.php
(23)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/detailHA.php
(1212)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2708)
23:34:14.844409 trace system.db.CDbCommand
Querying SQL: SELECT * FROM quick_facts WHERE state_code = "NC" AND
city_name = "Forsyth" LIMIT 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/countyquickfacts/quickfacts.php
(41)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/detailHA.php
(1212)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2708)
23:34:14.846366 trace system.db.CDbCommand
Querying SQL: select p.id_property,p.property_title, p.property_address
,p.property_city,p.property_state,p.property_type ,
p.property_zip,pd.header_description,pd.header_value,pp.photo,
        (((acos(sin(('0.0000' *pi()/180)) *
sin((`lat`*pi()/180))+cos(('0.0000' *pi()/180)) * cos((`lat`*pi()/180)) *
cos((('0.0000'- `lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as distance from
property p 
        left join property_photo pp on p.id_property = pp.id_property and
pp.status = 'Active'
        left join property_deals pd on pd.id_property = p.id_property WHERE
p.status = 'Approved' and p.property_state = 'NC' and p.property_type =
'premium' and p.prog_type='affordablehousing' GROUP BY p.id_property HAVING
distance <= 25 ORDER BY distance ASC LIMIT 5
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/affordablehousingnearby/affordablehousingnearby.php
(28)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/detailHA.php
(1225)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2708)
23:34:14.861855 trace system.CModule
Loading "uri" application component
in
/home/cavepear/rentalhousingdeals.com/protected/views/layouts/detailhalayout.php
(104)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2708)
in /home/cavepear/rentalhousingdeals.com/index.php (16)